USE [vigia_produccion]
GO
/****** Object:  StoredProcedure [dbo].[spGetDetallesMedicamento]    Script Date: 9/07/2025 11:39:26 a. m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		wmonroy
-- Create date: 26-02-2025
-- Description:	Obtener lista de medicamentos
-- =============================================

ALTER PROCEDURE [dbo].[spGetDetallesMedicamento]
    @IdMedicamento INT
AS
BEGIN
    SELECT Marca, PresentacionComercial,RegistroInvima, Cantidad,	UnidadMedida,FormaFarmaceutica
    FROM app.tblMedicamentosMece2024
    WHERE idtblMedicamentosMece2024 = @IdMedicamento
END

